2025-07-28 10:03:37,905 [ 212233 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-07-28 10:03:37,905 [ 212233 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:79, check_args_and_update_paths) 2025-07-28 10:03:37,905 [ 212233 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:90, check_args_and_update_paths) 2025-07-28 10:03:37,905 [ 212233 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:92, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_q0vlt9 --privileged --dns-search='.' --memory=30709026816 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=1 --color=no --durations=0 --report-log=parallel0_1.jsonl --report-log-exclude-logs-on-passed-tests test_attach_partition_using_copy/test.py::test_all_replicated test_attach_partition_using_copy/test.py::test_both_mergetree test_attach_partition_using_copy/test.py::test_not_work_on_different_disk test_attach_partition_using_copy/test.py::test_only_destination_replicated -vvv " altinityinfra/integration-tests-runner:226bfaf75ac1 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache Test order randomisation NOT enabled. Enable with --random-order or --random-order-bucket= rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: timeout-2.3.1, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0, random-order-1.1.1 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [4 items] scheduling tests via LoadFileScheduling test_attach_partition_using_copy/test.py::test_all_replicated [gw1] [ 25%] FAILED test_attach_partition_using_copy/test.py::test_all_replicated test_attach_partition_using_copy/test.py::test_both_mergetree [gw1] [ 50%] FAILED test_attach_partition_using_copy/test.py::test_both_mergetree test_attach_partition_using_copy/test.py::test_not_work_on_different_disk [gw1] [ 75%] FAILED test_attach_partition_using_copy/test.py::test_not_work_on_different_disk test_attach_partition_using_copy/test.py::test_only_destination_replicated [gw1] [100%] FAILED test_attach_partition_using_copy/test.py::test_only_destination_replicated =================================== FAILURES =================================== _____________________________ test_all_replicated ______________________________ [gw1] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = def test_all_replicated(start_cluster): cleanup([replica1, replica2]) > create_source_table(replica1, "source", True) test_attach_partition_using_copy/test.py:128: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ test_attach_partition_using_copy/test.py:40: in create_source_table node.query_with_retry( _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n price UInt32,\n ...disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/')\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7f18f9dbc040> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/source', 'replica1') E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.6): E Code: 198. DB::Exception: Received from 172.16.1.6:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000382e5051 E 1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001bd54ed1 E 2. ./src/Common/Exception.h:112: DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x000000001bcdf4af E 3. ./build_docker/./src/Common/DNSResolver.cpp:113: DB::(anonymous namespace)::hostByName(String const&) @ 0x000000001bcd865e E 4. ./build_docker/./src/Common/DNSResolver.cpp:138: DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x000000001bcd55e8 E 5. ./build_docker/./src/Common/DNSResolver.cpp:256: DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x000000001bcd6020 E 6. ./build_docker/./src/Common/DNSResolver.cpp:276: DB::DNSResolver::resolveHostAllInOriginOrder(String const&) @ 0x000000001bcd6d67 E 7. ./build_docker/./src/Common/HostResolvePool.cpp:54: std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x000000001c4f0840 E 8. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x000000001c4ecfc1 E 9. ./build_docker/./src/Common/HostResolvePool.cpp:66: DB::HostResolver::HostResolver(std::function> (String const&)>&&, String, Poco::Timespan) @ 0x000000001c4eca8d E 10. ./build_docker/./src/Common/HostResolvePool.cpp:53: DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x000000001c4ec454 E 11. ./src/Common/HostResolvePool.h:62: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x000000001c4f5cb0 E 12. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x000000001c4f582d E 13. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:851: DB::HostResolversPool::getResolver(String const&) @ 0x000000001c4f062b E 14. ./build_docker/./src/Common/HTTPConnectionPool.cpp:671: DB::EndpointConnectionPool::prepareNewConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d7d88 E 15. ./build_docker/./src/Common/HTTPConnectionPool.cpp:590: DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d6110 E 16. ./build_docker/./src/IO/HTTPCommon.cpp:63: DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x000000001c5005d4 E 17. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:267: DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x0000000021207352 E 18. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:285: DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x00000000212079dc E 19. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:408: DB::ReadWriteBufferFromHTTP::initialize() @ 0x0000000021208a5b E 20. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:472: void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x000000002120e378 E 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x00000000212033d1 E 22. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:465: DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x000000002120b083 E 23. DB::ReadBuffer::next() @ 0x000000000c5cc20b E 24. ./src/IO/ReadBuffer.h:96: DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x000000002864bb82 E 25. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:225: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x00000000286504df E 26. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:185: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x000000002864fe10 E 27. ./build_docker/./src/Disks/ObjectStorages/Web/MetadataStorageFromStaticFilesWebServer.cpp:106: DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x0000000028647f46 E 28. ./build_docker/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:785: DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000028553d3e E 29. ./build_docker/./src/Storages/MergeTree/MergeTreeData.cpp:380: DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000002eee6b10 E 30. ./build_docker/./src/Storages/StorageReplicatedMergeTree.cpp:414: DB::StorageReplicatedMergeTree::StorageReplicatedMergeTree(DB::TableZnodeInfo const&, DB::LoadingStrictnessLevel, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>, bool, DB::ZooKeeperRetriesInfo const&) @ 0x000000002e4918fc E 31. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr std::allocate_shared[abi:ne190107], DB::TableZnodeInfo&, DB::LoadingStrictnessLevel const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>, bool&, DB::ZooKeeperRetriesInfo&, 0>(std::allocator const&, DB::TableZnodeInfo&, DB::LoadingStrictnessLevel const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>&&, bool&, DB::ZooKeeperRetriesInfo&) @ 0x000000002f698181 E . (DNS_ERROR) E (query: ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/source', 'replica1') E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E ) helpers/cluster.py:3712: Exception ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml ------------------------------ Captured log setup ------------------------------ 2025-07-28 10:03:44.323000 [ 627 ] DEBUG : Command:[docker ps | wc -l] (cluster.py:121, run_and_check) 2025-07-28 10:03:44.342000 [ 627 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-07-28 10:03:44.342000 [ 627 ] DEBUG : No running containers (conftest.py:95, cleanup_environment) 2025-07-28 10:03:44.342000 [ 627 ] DEBUG : Pruning Docker networks (conftest.py:97, cleanup_environment) 2025-07-28 10:03:44.342000 [ 627 ] DEBUG : Command:[docker network prune --force] (cluster.py:121, run_and_check) 2025-07-28 10:03:44.369000 [ 627 ] DEBUG : Command:[sysctl net.ipv4.ip_local_port_range='55000 65535'] (cluster.py:121, run_and_check) 2025-07-28 10:03:44.373000 [ 627 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:145, run_and_check) 2025-07-28 10:03:44.374000 [ 627 ] INFO : Running tests in /ClickHouse/tests/integration/test_attach_partition_using_copy/test.py (cluster.py:2738, start) 2025-07-28 10:03:44.375000 [ 627 ] DEBUG : Cluster start called. is_up=False (cluster.py:2745, start) 2025-07-28 10:03:44.400000 [ 627 ] DEBUG : Docker networks for project roottestattachpartitionusingcopy-gw1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:03:44.427000 [ 627 ] DEBUG : Docker containers for project roottestattachpartitionusingcopy-gw1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:03:44.448000 [ 627 ] DEBUG : Docker volumes for project roottestattachpartitionusingcopy-gw1 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:03:44.448000 [ 627 ] DEBUG : Cleanup called (cluster.py:851, cleanup) 2025-07-28 10:03:44.476000 [ 627 ] DEBUG : Docker networks for project roottestattachpartitionusingcopy-gw1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:03:44.504000 [ 627 ] DEBUG : Docker containers for project roottestattachpartitionusingcopy-gw1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:03:44.533000 [ 627 ] DEBUG : Docker volumes for project roottestattachpartitionusingcopy-gw1 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:03:44.534000 [ 627 ] DEBUG : Command:[docker container list --all --filter name='^/roottestattachpartitionusingcopy-gw1-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-07-28 10:03:44.560000 [ 627 ] DEBUG : Unstopped containers: {} (cluster.py:865, cleanup) 2025-07-28 10:03:44.560000 [ 627 ] DEBUG : No running containers for project: roottestattachpartitionusingcopy-gw1 (cluster.py:879, cleanup) 2025-07-28 10:03:44.560000 [ 627 ] DEBUG : Trying to prune unused networks... (cluster.py:885, cleanup) 2025-07-28 10:03:44.575000 [ 627 ] DEBUG : Trying to prune unused images... (cluster.py:901, cleanup) 2025-07-28 10:03:44.575000 [ 627 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-07-28 10:03:44.602000 [ 627 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-07-28 10:03:44.602000 [ 627 ] DEBUG : Images pruned (cluster.py:904, cleanup) 2025-07-28 10:03:44.602000 [ 627 ] DEBUG : Trying to prune unused volumes... (cluster.py:910, cleanup) 2025-07-28 10:03:44.602000 [ 627 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-07-28 10:03:44.623000 [ 627 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-07-28 10:03:44.624000 [ 627 ] DEBUG : Volumes pruned: 1 (cluster.py:915, cleanup) 2025-07-28 10:03:44.624000 [ 627 ] DEBUG : Setup directory for instance: replica1 (cluster.py:2758, start) 2025-07-28 10:03:44.625000 [ 627 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4628, create_dir) 2025-07-28 10:03:44.626000 [ 627 ] DEBUG : Create directory for common tests configuration (cluster.py:4633, create_dir) 2025-07-28 10:03:44.626000 [ 627 ] DEBUG : Copy common configuration from helpers (cluster.py:4653, create_dir) 2025-07-28 10:03:44.627000 [ 627 ] DEBUG : Generate and write macros file (cluster.py:4705, create_dir) 2025-07-28 10:03:44.628000 [ 627 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_attach_partition_using_copy/configs/remote_servers.xml'] to /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/configs/config.d (cluster.py:4741, create_dir) 2025-07-28 10:03:44.629000 [ 627 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/database (cluster.py:4758, create_dir) 2025-07-28 10:03:44.629000 [ 627 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/logs (cluster.py:4769, create_dir) 2025-07-28 10:03:44.629000 [ 627 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4850, create_dir) 2025-07-28 10:03:44.630000 [ 627 ] DEBUG : Setup directory for instance: replica2 (cluster.py:2758, start) 2025-07-28 10:03:44.630000 [ 627 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4628, create_dir) 2025-07-28 10:03:44.631000 [ 627 ] DEBUG : Create directory for common tests configuration (cluster.py:4633, create_dir) 2025-07-28 10:03:44.631000 [ 627 ] DEBUG : Copy common configuration from helpers (cluster.py:4653, create_dir) 2025-07-28 10:03:44.632000 [ 627 ] DEBUG : Generate and write macros file (cluster.py:4705, create_dir) 2025-07-28 10:03:44.633000 [ 627 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_attach_partition_using_copy/configs/remote_servers.xml'] to /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/configs/config.d (cluster.py:4741, create_dir) 2025-07-28 10:03:44.633000 [ 627 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/database (cluster.py:4758, create_dir) 2025-07-28 10:03:44.633000 [ 627 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/logs (cluster.py:4769, create_dir) 2025-07-28 10:03:44.634000 [ 627 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4850, create_dir) 2025-07-28 10:03:44.635000 [ 627 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'keeper_binary': '/clickhouse', 'keeper_cmd_prefix': 'clickhouse keeper', 'image': 'altinityinfra/integration-test:5ccda723c1fc', 'user': '0', 'keeper_fs': 'bind', 'keeper_logs_dir1': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper1/log', 'keeper_config_dir1': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper1/config', 'keeper_db_dir1': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper1/coordination', 'keeper_logs_dir2': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper2/log', 'keeper_config_dir2': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper2/config', 'keeper_db_dir2': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper2/coordination', 'keeper_logs_dir3': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper3/log', 'keeper_config_dir3': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper3/config', 'keeper_db_dir3': '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper3/coordination'} stored in /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env (cluster.py:96, _create_env_file) 2025-07-28 10:03:44.635000 [ 627 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-07-28 10:03:44.636000 [ 627 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-07-28 10:03:44.636000 [ 627 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-07-28 10:03:44.636000 [ 627 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-07-28 10:03:44.650000 [ 627 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:547, _make_request) 2025-07-28 10:03:44.651000 [ 627 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env --project-name roottestattachpartitionusingcopy-gw1 --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/docker-compose.yml pull] (cluster.py:121, run_and_check) 2025-07-28 10:03:55.099000 [ 627 ] DEBUG : Stderr: zoo3 Skipped - Image is already being pulled by zoo2 (cluster.py:147, run_and_check) 2025-07-28 10:03:55.099000 [ 627 ] DEBUG : Stderr: replica2 Skipped - Image is already being pulled by zoo2 (cluster.py:147, run_and_check) 2025-07-28 10:03:55.099000 [ 627 ] DEBUG : Stderr: replica1 Skipped - Image is already being pulled by zoo2 (cluster.py:147, run_and_check) 2025-07-28 10:03:55.099000 [ 627 ] DEBUG : Stderr: zoo1 Skipped - Image is already being pulled by zoo2 (cluster.py:147, run_and_check) 2025-07-28 10:03:55.099000 [ 627 ] DEBUG : Stderr: zoo2 Pulling (cluster.py:147, run_and_check) 2025-07-28 10:03:55.100000 [ 627 ] DEBUG : Stderr: zoo2 Pulled (cluster.py:147, run_and_check) 2025-07-28 10:03:55.100000 [ 627 ] DEBUG : Setup ZooKeeper (cluster.py:2799, start) 2025-07-28 10:03:55.100000 [ 627 ] DEBUG : Creating internal ZooKeeper dirs: ['/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper1/log', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper1/config', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper1/coordination', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper2/log', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper2/config', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper2/coordination', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper3/log', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper3/config', '/ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/keeper3/coordination'] (cluster.py:2800, start) 2025-07-28 10:03:55.101000 [ 627 ] DEBUG : Command:[docker compose --project-name roottestattachpartitionusingcopy-gw1 --env-file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --verbose up -d] (cluster.py:121, run_and_check) 2025-07-28 10:03:55.838000 [ 627 ] DEBUG : Stderr:time="2025-07-28T10:03:55Z" level=trace msg="Docker Desktop integration not enabled" (cluster.py:147, run_and_check) 2025-07-28 10:03:55.838000 [ 627 ] DEBUG : Stderr: Network roottestattachpartitionusingcopy-gw1_default Creating (cluster.py:147, run_and_check) 2025-07-28 10:03:55.838000 [ 627 ] DEBUG : Stderr: Network roottestattachpartitionusingcopy-gw1_default Created (cluster.py:147, run_and_check) 2025-07-28 10:03:55.838000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Creating (cluster.py:147, run_and_check) 2025-07-28 10:03:55.838000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Creating (cluster.py:147, run_and_check) 2025-07-28 10:03:55.838000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Creating (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Created (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Created (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Created (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Starting (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Starting (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Starting (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Started (cluster.py:147, run_and_check) 2025-07-28 10:03:55.839000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Started (cluster.py:147, run_and_check) 2025-07-28 10:03:55.840000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Started (cluster.py:147, run_and_check) 2025-07-28 10:03:55.840000 [ 627 ] DEBUG : Stderr:time="2025-07-28T10:03:55Z" level=debug msg="otel error" error="" (cluster.py:147, run_and_check) 2025-07-28 10:03:55.840000 [ 627 ] DEBUG : Stderr:time="2025-07-28T10:03:55Z" level=debug msg="otel error" error="" (cluster.py:147, run_and_check) 2025-07-28 10:03:55.840000 [ 627 ] DEBUG : Wait ZooKeeper to start (cluster.py:2436, wait_zookeeper_to_start) 2025-07-28 10:03:55.840000 [ 627 ] DEBUG : get_instance_ip instance_name=zoo1 (cluster.py:2005, get_instance_ip) 2025-07-28 10:03:55.843000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-zoo1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:03:55.844000 [ 627 ] DEBUG : get_kazoo_client: zoo1, ip:172.16.1.4, port:2181, use_ssl:False (cluster.py:3312, get_kazoo_client) 2025-07-28 10:03:55.845000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:55.846000 [ 627 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-07-28 10:03:55.907000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:55.908000 [ 627 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-07-28 10:03:56.057000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:56.057000 [ 627 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-07-28 10:03:56.256000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:56.257000 [ 627 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-07-28 10:03:56.616000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:56.617000 [ 627 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-07-28 10:03:57.588000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:57.589000 [ 627 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-07-28 10:03:59.908000 [ 627 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:03:59.909000 [ 627 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-07-28 10:03:59.916000 [ 627 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-07-28 10:03:59.917000 [ 627 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-07-28 10:03:59.918000 [ 627 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-07-28 10:03:59.918000 [ 627 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-07-28 10:03:59.922000 [ 627 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-07-28 10:03:59.922000 [ 627 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-07-28 10:03:59.922000 [ 627 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-07-28 10:04:00.022000 [ 627 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-07-28 10:04:00.023000 [ 627 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-07-28 10:04:00.023000 [ 627 ] DEBUG : get_instance_ip instance_name=zoo2 (cluster.py:2005, get_instance_ip) 2025-07-28 10:04:00.025000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-zoo2-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:00.026000 [ 627 ] DEBUG : get_kazoo_client: zoo2, ip:172.16.1.3, port:2181, use_ssl:False (cluster.py:3312, get_kazoo_client) 2025-07-28 10:04:00.027000 [ 627 ] INFO : Connecting to 172.16.1.3(172.16.1.3):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:04:00.028000 [ 627 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-07-28 10:04:00.031000 [ 627 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-07-28 10:04:00.032000 [ 627 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-07-28 10:04:00.033000 [ 627 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-07-28 10:04:00.033000 [ 627 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-07-28 10:04:00.036000 [ 627 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-07-28 10:04:00.037000 [ 627 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-07-28 10:04:00.037000 [ 627 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-07-28 10:04:00.137000 [ 627 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-07-28 10:04:00.137000 [ 627 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-07-28 10:04:00.138000 [ 627 ] DEBUG : get_instance_ip instance_name=zoo3 (cluster.py:2005, get_instance_ip) 2025-07-28 10:04:00.140000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-zoo3-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:00.140000 [ 627 ] DEBUG : get_kazoo_client: zoo3, ip:172.16.1.2, port:2181, use_ssl:False (cluster.py:3312, get_kazoo_client) 2025-07-28 10:04:00.141000 [ 627 ] INFO : Connecting to 172.16.1.2(172.16.1.2):2181, use_ssl: False (connection.py:650, _connect) 2025-07-28 10:04:00.142000 [ 627 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-07-28 10:04:00.148000 [ 627 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-07-28 10:04:00.149000 [ 627 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-07-28 10:04:00.150000 [ 627 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-07-28 10:04:00.150000 [ 627 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-07-28 10:04:00.154000 [ 627 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-07-28 10:04:00.154000 [ 627 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-07-28 10:04:00.154000 [ 627 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-07-28 10:04:00.255000 [ 627 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-07-28 10:04:00.255000 [ 627 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-07-28 10:04:00.256000 [ 627 ] DEBUG : All instances of ZooKeeper started: ('zoo1', 'zoo2', 'zoo3') (cluster.py:2452, wait_zookeeper_nodes_to_start) 2025-07-28 10:04:00.256000 [ 627 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker compose --env-file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env --project-name roottestattachpartitionusingcopy-gw1 --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/docker-compose.yml up -d --no-recreate') (cluster.py:3139, start) 2025-07-28 10:04:00.257000 [ 627 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env --project-name roottestattachpartitionusingcopy-gw1 --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/docker-compose.yml up -d --no-recreate] (cluster.py:121, run_and_check) 2025-07-28 10:04:00.807000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Running (cluster.py:147, run_and_check) 2025-07-28 10:04:00.807000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Running (cluster.py:147, run_and_check) 2025-07-28 10:04:00.807000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Running (cluster.py:147, run_and_check) 2025-07-28 10:04:00.807000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Creating (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Creating (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Created (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Created (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Starting (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Starting (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Started (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Started (cluster.py:147, run_and_check) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : ClickHouse instance created (cluster.py:3147, start) 2025-07-28 10:04:00.808000 [ 627 ] DEBUG : get_instance_ip instance_name=replica1 (cluster.py:2005, get_instance_ip) 2025-07-28 10:04:00.812000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-replica1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:00.812000 [ 627 ] DEBUG : get_instance_ip instance_name=replica1 (cluster.py:2015, get_instance_global_ipv6) 2025-07-28 10:04:00.815000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-replica1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:00.815000 [ 627 ] DEBUG : Waiting for ClickHouse start in replica1, ip: 172.16.1.6... (cluster.py:3155, start) 2025-07-28 10:04:00.818000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-replica1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:00.821000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:00.924000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.027000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.129000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.232000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.335000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.438000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.541000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.644000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.746000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.850000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:01.954000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.057000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.160000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.263000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/04591e49351ce1f9190722737f1ac94a993abd8dec72cfb7b73b0bcf757ceec0/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.263000 [ 627 ] DEBUG : ClickHouse replica1 started (cluster.py:3159, start) 2025-07-28 10:04:02.264000 [ 627 ] DEBUG : get_instance_ip instance_name=replica2 (cluster.py:2005, get_instance_ip) 2025-07-28 10:04:02.266000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-replica2-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.267000 [ 627 ] DEBUG : get_instance_ip instance_name=replica2 (cluster.py:2015, get_instance_global_ipv6) 2025-07-28 10:04:02.268000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-replica2-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.269000 [ 627 ] DEBUG : Waiting for ClickHouse start in replica2, ip: 172.16.1.5... (cluster.py:3155, start) 2025-07-28 10:04:02.271000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestattachpartitionusingcopy-gw1-replica2-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.272000 [ 627 ] DEBUG : http://localhost:None "GET /v1.46/containers/be0f7f1eceb3e9b4fa86e64e74441582412aabcd15a29638c76c08ebebd0b27f/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:04:02.273000 [ 627 ] DEBUG : ClickHouse replica2 started (cluster.py:3159, start) ------------------------------ Captured log call ------------------------------- 2025-07-28 10:04:02.275000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:04:02.490000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:04:02.707000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:04:02.973000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:04:03.239000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/source', 'replica1') ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:04:57.176000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/source', 'replica1') ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:05:51.711000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/source', 'replica1') ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) _____________________________ test_both_mergetree ______________________________ [gw1] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = def test_both_mergetree(start_cluster): cleanup([replica1, replica2]) > create_source_table(replica1, "source", False) test_attach_partition_using_copy/test.py:106: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ test_attach_partition_using_copy/test.py:40: in create_source_table node.query_with_retry( _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n price UInt32,\n ...disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/')\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7f18f9dbc040> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree() E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.6): E Code: 198. DB::Exception: Received from 172.16.1.6:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000382e5051 E 1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001bd54ed1 E 2. ./src/Common/Exception.h:112: DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x000000001bcdf4af E 3. ./build_docker/./src/Common/DNSResolver.cpp:113: DB::(anonymous namespace)::hostByName(String const&) @ 0x000000001bcd865e E 4. ./build_docker/./src/Common/DNSResolver.cpp:138: DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x000000001bcd55e8 E 5. ./build_docker/./src/Common/DNSResolver.cpp:256: DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x000000001bcd6020 E 6. ./build_docker/./src/Common/DNSResolver.cpp:276: DB::DNSResolver::resolveHostAllInOriginOrder(String const&) @ 0x000000001bcd6d67 E 7. ./build_docker/./src/Common/HostResolvePool.cpp:54: std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x000000001c4f0840 E 8. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x000000001c4ecfc1 E 9. ./build_docker/./src/Common/HostResolvePool.cpp:66: DB::HostResolver::HostResolver(std::function> (String const&)>&&, String, Poco::Timespan) @ 0x000000001c4eca8d E 10. ./build_docker/./src/Common/HostResolvePool.cpp:53: DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x000000001c4ec454 E 11. ./src/Common/HostResolvePool.h:62: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x000000001c4f5cb0 E 12. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x000000001c4f582d E 13. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:851: DB::HostResolversPool::getResolver(String const&) @ 0x000000001c4f062b E 14. ./build_docker/./src/Common/HTTPConnectionPool.cpp:671: DB::EndpointConnectionPool::prepareNewConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d7d88 E 15. ./build_docker/./src/Common/HTTPConnectionPool.cpp:590: DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d6110 E 16. ./build_docker/./src/IO/HTTPCommon.cpp:63: DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x000000001c5005d4 E 17. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:267: DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x0000000021207352 E 18. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:285: DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x00000000212079dc E 19. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:408: DB::ReadWriteBufferFromHTTP::initialize() @ 0x0000000021208a5b E 20. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:472: void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x000000002120e378 E 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x00000000212033d1 E 22. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:465: DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x000000002120b083 E 23. DB::ReadBuffer::next() @ 0x000000000c5cc20b E 24. ./src/IO/ReadBuffer.h:96: DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x000000002864bb82 E 25. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:225: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x00000000286504df E 26. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:185: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x000000002864fe10 E 27. ./build_docker/./src/Disks/ObjectStorages/Web/MetadataStorageFromStaticFilesWebServer.cpp:106: DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x0000000028647f46 E 28. ./build_docker/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:785: DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000028553d3e E 29. ./build_docker/./src/Storages/MergeTree/MergeTreeData.cpp:380: DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000002eee6b10 E 30. ./build_docker/./src/Storages/StorageMergeTree.cpp:159: DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x000000002f698f96 E 31. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr std::allocate_shared[abi:ne190107], DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>, 0>(std::allocator const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>&&) @ 0x000000002f6985f6 E . (DNS_ERROR) E (query: ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree() E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E ) helpers/cluster.py:3712: Exception ------------------------------ Captured log call ------------------------------- 2025-07-28 10:06:47.119000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:06:47.334000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:06:47.551000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:06:47.818000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:06:48.085000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:07:43.983000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:08:41.786000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) _______________________ test_not_work_on_different_disk ________________________ [gw1] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = def test_not_work_on_different_disk(start_cluster): cleanup([replica1, replica2]) # Replace and move should not work on replace > create_source_table(replica1, "source", False) test_attach_partition_using_copy/test.py:199: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ test_attach_partition_using_copy/test.py:40: in create_source_table node.query_with_retry( _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n price UInt32,\n ...disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/')\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7f18f9dbc040> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree() E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.6): E Code: 198. DB::Exception: Received from 172.16.1.6:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000382e5051 E 1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001bd54ed1 E 2. ./src/Common/Exception.h:112: DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x000000001bcdf4af E 3. ./build_docker/./src/Common/DNSResolver.cpp:113: DB::(anonymous namespace)::hostByName(String const&) @ 0x000000001bcd865e E 4. ./build_docker/./src/Common/DNSResolver.cpp:138: DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x000000001bcd55e8 E 5. ./build_docker/./src/Common/DNSResolver.cpp:256: DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x000000001bcd6020 E 6. ./build_docker/./src/Common/DNSResolver.cpp:276: DB::DNSResolver::resolveHostAllInOriginOrder(String const&) @ 0x000000001bcd6d67 E 7. ./build_docker/./src/Common/HostResolvePool.cpp:54: std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x000000001c4f0840 E 8. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x000000001c4ecfc1 E 9. ./build_docker/./src/Common/HostResolvePool.cpp:66: DB::HostResolver::HostResolver(std::function> (String const&)>&&, String, Poco::Timespan) @ 0x000000001c4eca8d E 10. ./build_docker/./src/Common/HostResolvePool.cpp:53: DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x000000001c4ec454 E 11. ./src/Common/HostResolvePool.h:62: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x000000001c4f5cb0 E 12. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x000000001c4f582d E 13. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:851: DB::HostResolversPool::getResolver(String const&) @ 0x000000001c4f062b E 14. ./build_docker/./src/Common/HTTPConnectionPool.cpp:671: DB::EndpointConnectionPool::prepareNewConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d7d88 E 15. ./build_docker/./src/Common/HTTPConnectionPool.cpp:590: DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d6110 E 16. ./build_docker/./src/IO/HTTPCommon.cpp:63: DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x000000001c5005d4 E 17. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:267: DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x0000000021207352 E 18. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:285: DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x00000000212079dc E 19. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:408: DB::ReadWriteBufferFromHTTP::initialize() @ 0x0000000021208a5b E 20. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:472: void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x000000002120e378 E 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x00000000212033d1 E 22. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:465: DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x000000002120b083 E 23. DB::ReadBuffer::next() @ 0x000000000c5cc20b E 24. ./src/IO/ReadBuffer.h:96: DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x000000002864bb82 E 25. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:225: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x00000000286504df E 26. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:185: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x000000002864fe10 E 27. ./build_docker/./src/Disks/ObjectStorages/Web/MetadataStorageFromStaticFilesWebServer.cpp:106: DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x0000000028647f46 E 28. ./build_docker/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:785: DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000028553d3e E 29. ./build_docker/./src/Storages/MergeTree/MergeTreeData.cpp:380: DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000002eee6b10 E 30. ./build_docker/./src/Storages/StorageMergeTree.cpp:159: DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x000000002f698f96 E 31. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr std::allocate_shared[abi:ne190107], DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>, 0>(std::allocator const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>&&) @ 0x000000002f6985f6 E . (DNS_ERROR) E (query: ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree() E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E ) helpers/cluster.py:3712: Exception ------------------------------ Captured log call ------------------------------- 2025-07-28 10:09:36.445000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:09:36.661000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:09:36.876000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:09:37.092000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:09:37.307000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:10:31.994000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:11:29.093000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) _______________________ test_only_destination_replicated _______________________ [gw1] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = def test_only_destination_replicated(start_cluster): cleanup([replica1, replica2]) > create_source_table(replica1, "source", False) test_attach_partition_using_copy/test.py:163: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ test_attach_partition_using_copy/test.py:40: in create_source_table node.query_with_retry( _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n price UInt32,\n ...disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/')\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7f18f9dbc040> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree() E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.6): E Code: 198. DB::Exception: Received from 172.16.1.6:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000382e5051 E 1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001bd54ed1 E 2. ./src/Common/Exception.h:112: DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x000000001bcdf4af E 3. ./build_docker/./src/Common/DNSResolver.cpp:113: DB::(anonymous namespace)::hostByName(String const&) @ 0x000000001bcd865e E 4. ./build_docker/./src/Common/DNSResolver.cpp:138: DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x000000001bcd55e8 E 5. ./build_docker/./src/Common/DNSResolver.cpp:256: DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x000000001bcd6020 E 6. ./build_docker/./src/Common/DNSResolver.cpp:276: DB::DNSResolver::resolveHostAllInOriginOrder(String const&) @ 0x000000001bcd6d67 E 7. ./build_docker/./src/Common/HostResolvePool.cpp:54: std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x000000001c4f0840 E 8. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x000000001c4ecfc1 E 9. ./build_docker/./src/Common/HostResolvePool.cpp:66: DB::HostResolver::HostResolver(std::function> (String const&)>&&, String, Poco::Timespan) @ 0x000000001c4eca8d E 10. ./build_docker/./src/Common/HostResolvePool.cpp:53: DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x000000001c4ec454 E 11. ./src/Common/HostResolvePool.h:62: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x000000001c4f5cb0 E 12. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x000000001c4f582d E 13. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:851: DB::HostResolversPool::getResolver(String const&) @ 0x000000001c4f062b E 14. ./build_docker/./src/Common/HTTPConnectionPool.cpp:671: DB::EndpointConnectionPool::prepareNewConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d7d88 E 15. ./build_docker/./src/Common/HTTPConnectionPool.cpp:590: DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000001c4d6110 E 16. ./build_docker/./src/IO/HTTPCommon.cpp:63: DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x000000001c5005d4 E 17. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:267: DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x0000000021207352 E 18. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:285: DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x00000000212079dc E 19. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:408: DB::ReadWriteBufferFromHTTP::initialize() @ 0x0000000021208a5b E 20. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:472: void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x000000002120e378 E 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x00000000212033d1 E 22. ./build_docker/./src/IO/ReadWriteBufferFromHTTP.cpp:465: DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x000000002120b083 E 23. DB::ReadBuffer::next() @ 0x000000000c5cc20b E 24. ./src/IO/ReadBuffer.h:96: DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x000000002864bb82 E 25. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:225: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x00000000286504df E 26. ./build_docker/./src/Disks/ObjectStorages/Web/WebObjectStorage.cpp:185: DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x000000002864fe10 E 27. ./build_docker/./src/Disks/ObjectStorages/Web/MetadataStorageFromStaticFilesWebServer.cpp:106: DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x0000000028647f46 E 28. ./build_docker/./src/Disks/ObjectStorages/DiskObjectStorage.cpp:785: DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000028553d3e E 29. ./build_docker/./src/Storages/MergeTree/MergeTreeData.cpp:380: DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000002eee6b10 E 30. ./build_docker/./src/Storages/StorageMergeTree.cpp:159: DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x000000002f698f96 E 31. ./contrib/llvm-project/libcxx/include/__memory/construct_at.h:41: std::shared_ptr std::allocate_shared[abi:ne190107], DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>, 0>(std::allocator const&, DB::StorageID const&, String const&, DB::StorageInMemoryMetadata&, DB::LoadingStrictnessLevel const&, std::shared_ptr&, String&, DB::MergeTreeData::MergingParams&, std::unique_ptr>&&) @ 0x000000002f6985f6 E . (DNS_ERROR) E (query: ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree() E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') E ) helpers/cluster.py:3712: Exception ------------------------------ Captured log call ------------------------------- 2025-07-28 10:12:26.912000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:12:27.128000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica1 (cluster.py:3648, query) 2025-07-28 10:12:27.343000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS source SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:12:27.559000 [ 627 ] DEBUG : Executing query DROP TABLE IF EXISTS destination SYNC on replica2 (cluster.py:3648, query) 2025-07-28 10:12:27.774000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:13:21.659000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) 2025-07-28 10:14:16.845000 [ 627 ] DEBUG : Executing query ATTACH TABLE source UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree() ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/main/web/') on replica1 (cluster.py:3648, query) ---------------------------- Captured log teardown ----------------------------- 2025-07-28 10:15:14.027000 [ 627 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env --project-name roottestattachpartitionusingcopy-gw1 --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/docker-compose.yml stop --timeout 20] (cluster.py:121, run_and_check) 2025-07-28 10:15:20.824000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:20.824000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:20.825000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:20.825000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:20.825000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:20.825000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:20.826000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:20.826000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:20.826000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:20.826000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:20.826000 [ 627 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-07-28 10:15:20.840000 [ 627 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-07-28 10:15:20.854000 [ 627 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/.env --project-name roottestattachpartitionusingcopy-gw1 --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_attach_partition_using_copy/_instances-1-gw1/replica2/docker-compose.yml down --volumes] (cluster.py:121, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica1-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-replica2-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:21.334000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo1-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo2-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Container roottestattachpartitionusingcopy-gw1-zoo3-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Network roottestattachpartitionusingcopy-gw1_default Removing (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Stderr: Network roottestattachpartitionusingcopy-gw1_default Removed (cluster.py:147, run_and_check) 2025-07-28 10:15:21.335000 [ 627 ] DEBUG : Cleanup called (cluster.py:851, cleanup) 2025-07-28 10:15:21.350000 [ 627 ] DEBUG : Docker networks for project roottestattachpartitionusingcopy-gw1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:15:21.367000 [ 627 ] DEBUG : Docker containers for project roottestattachpartitionusingcopy-gw1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:15:21.384000 [ 627 ] DEBUG : Docker volumes for project roottestattachpartitionusingcopy-gw1 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:15:21.384000 [ 627 ] DEBUG : Command:[docker container list --all --filter name='^/roottestattachpartitionusingcopy-gw1-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-07-28 10:15:21.403000 [ 627 ] DEBUG : Unstopped containers: {} (cluster.py:865, cleanup) 2025-07-28 10:15:21.404000 [ 627 ] DEBUG : No running containers for project: roottestattachpartitionusingcopy-gw1 (cluster.py:879, cleanup) 2025-07-28 10:15:21.404000 [ 627 ] DEBUG : Trying to prune unused networks... (cluster.py:885, cleanup) 2025-07-28 10:15:21.422000 [ 627 ] DEBUG : Trying to prune unused images... (cluster.py:901, cleanup) 2025-07-28 10:15:21.422000 [ 627 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-07-28 10:15:21.447000 [ 627 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-07-28 10:15:21.447000 [ 627 ] DEBUG : Images pruned (cluster.py:904, cleanup) 2025-07-28 10:15:21.448000 [ 627 ] DEBUG : Trying to prune unused volumes... (cluster.py:910, cleanup) 2025-07-28 10:15:21.448000 [ 627 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-07-28 10:15:21.468000 [ 627 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-07-28 10:15:21.469000 [ 627 ] DEBUG : Volumes pruned: 1 (cluster.py:915, cleanup) ----------------- generated report log file: parallel0_1.jsonl ----------------- ============================== slowest durations =============================== 170.40s call test_attach_partition_using_copy/test.py::test_not_work_on_different_disk 169.25s call test_attach_partition_using_copy/test.py::test_both_mergetree 166.98s call test_attach_partition_using_copy/test.py::test_only_destination_replicated 164.67s call test_attach_partition_using_copy/test.py::test_all_replicated 17.95s setup test_attach_partition_using_copy/test.py::test_all_replicated 7.44s teardown test_attach_partition_using_copy/test.py::test_only_destination_replicated 0.00s teardown test_attach_partition_using_copy/test.py::test_all_replicated 0.00s teardown test_attach_partition_using_copy/test.py::test_not_work_on_different_disk 0.00s teardown test_attach_partition_using_copy/test.py::test_both_mergetree 0.00s setup test_attach_partition_using_copy/test.py::test_only_destination_replicated 0.00s setup test_attach_partition_using_copy/test.py::test_both_mergetree 0.00s setup test_attach_partition_using_copy/test.py::test_not_work_on_different_disk =========================== short test summary info ============================ FAILED test_attach_partition_using_copy/test.py::test_all_replicated - Except... FAILED test_attach_partition_using_copy/test.py::test_both_mergetree - Except... FAILED test_attach_partition_using_copy/test.py::test_not_work_on_different_disk FAILED test_attach_partition_using_copy/test.py::test_only_destination_replicated ======================== 4 failed in 699.30s (0:11:39) ========================= Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 492, in subprocess.check_call(cmd, shell=True, bufsize=0) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_q0vlt9 --privileged --dns-search='.' --memory=30709026816 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=1 --color=no --durations=0 --report-log=parallel0_1.jsonl --report-log-exclude-logs-on-passed-tests test_attach_partition_using_copy/test.py::test_all_replicated test_attach_partition_using_copy/test.py::test_both_mergetree test_attach_partition_using_copy/test.py::test_not_work_on_different_disk test_attach_partition_using_copy/test.py::test_only_destination_replicated -vvv " altinityinfra/integration-tests-runner:226bfaf75ac1 ' returned non-zero exit status 1.